<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1" Build="10.50.1746.0">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementText="select&#xA;    count(a.Id) as [Accepted Answers],&#xA;    sum(case when a.Score = 0 then 0 else 1 end) as [Scored Answers],  &#xA;    sum(case when a.Score = 0 then 1 else 0 end) as [Unscored Answers],&#xA;    sum(CASE WHEN a.Score = 0 then 1 else 0 end)*1000 / count(a.Id) / 10.0 as [Percentage Unscored]&#xA;from&#xA;    Posts q&#xA;  inner join&#xA;    Posts a&#xA;  on a.Id = q.AcceptedAnswerId&#xA;where&#xA;      a.CommunityOwnedDate is null&#xA;  and a.OwnerUserId = 1&#xA;  and q.OwnerUserId != 1&#xA;  and a.postTypeId = 2" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSubTreeCost="666.327" StatementEstRows="1" StatementOptmLevel="FULL" QueryHash="0x05977150AF7E09E2" QueryPlanHash="0x7B68EA3E7CA92FCE">
          <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
          <QueryPlan DegreeOfParallelism="8" MemoryGrant="8640" CachedPlanSize="80" CompileTime="26" CompileCPU="26" CompileMemory="984">
            <MissingIndexes>
              <MissingIndexGroup Impact="96.1914">
                <MissingIndex Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]">
                  <ColumnGroup Usage="INEQUALITY">
                    <Column Name="[OwnerUserId]" ColumnId="10" />
                  </ColumnGroup>
                  <ColumnGroup Usage="INCLUDE">
                    <Column Name="[AcceptedAnswerId]" ColumnId="4" />
                  </ColumnGroup>
                </MissingIndex>
              </MissingIndexGroup>
              <MissingIndexGroup Impact="99.873">
                <MissingIndex Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]">
                  <ColumnGroup Usage="EQUALITY">
                    <Column Name="[AcceptedAnswerId]" ColumnId="4" />
                  </ColumnGroup>
                  <ColumnGroup Usage="INCLUDE">
                    <Column Name="[OwnerUserId]" ColumnId="10" />
                  </ColumnGroup>
                </MissingIndex>
              </MissingIndexGroup>
            </MissingIndexes>
            <RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="28" EstimatedTotalSubtreeCost="666.327" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
              <OutputList>
                <ColumnReference Column="Expr1004" />
                <ColumnReference Column="Expr1005" />
                <ColumnReference Column="Expr1006" />
                <ColumnReference Column="Expr1007" />
              </OutputList>
              <ComputeScalar>
                <DefinedValues>
                  <DefinedValue>
                    <ColumnReference Column="Expr1007" />
                    <ScalarOperator ScalarString="CONVERT_IMPLICIT(numeric(10,0),([Expr1006]*(1000))/[Expr1004],0)/(10.0)">
                      <Arithmetic Operation="DIV">
                        <ScalarOperator>
                          <Convert DataType="numeric" Precision="10" Scale="0" Style="0" Implicit="1">
                            <ScalarOperator>
                              <Arithmetic Operation="DIV">
                                <ScalarOperator>
                                  <Arithmetic Operation="MULT">
                                    <ScalarOperator>
                                      <Identifier>
                                        <ColumnReference Column="Expr1006" />
                                      </Identifier>
                                    </ScalarOperator>
                                    <ScalarOperator>
                                      <Const ConstValue="(1000)" />
                                    </ScalarOperator>
                                  </Arithmetic>
                                </ScalarOperator>
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="Expr1004" />
                                  </Identifier>
                                </ScalarOperator>
                              </Arithmetic>
                            </ScalarOperator>
                          </Convert>
                        </ScalarOperator>
                        <ScalarOperator>
                          <Const ConstValue="(10.0)" />
                        </ScalarOperator>
                      </Arithmetic>
                    </ScalarOperator>
                  </DefinedValue>
                </DefinedValues>
                <RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="19" EstimatedTotalSubtreeCost="666.327" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                    <ColumnReference Column="Expr1004" />
                    <ColumnReference Column="Expr1005" />
                    <ColumnReference Column="Expr1006" />
                  </OutputList>
                  <ComputeScalar>
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Column="Expr1004" />
                        <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1013],0)">
                          <Convert DataType="int" Style="0" Implicit="1">
                            <ScalarOperator>
                              <Identifier>
                                <ColumnReference Column="globalagg1013" />
                              </Identifier>
                            </ScalarOperator>
                          </Convert>
                        </ScalarOperator>
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Column="Expr1005" />
                        <ScalarOperator ScalarString="CASE WHEN [globalagg1015]=(0) THEN NULL ELSE [globalagg1017] END">
                          <IF>
                            <Condition>
                              <ScalarOperator>
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="globalagg1015" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="(0)" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Condition>
                            <Then>
                              <ScalarOperator>
                                <Const ConstValue="NULL" />
                              </ScalarOperator>
                            </Then>
                            <Else>
                              <ScalarOperator>
                                <Identifier>
                                  <ColumnReference Column="globalagg1017" />
                                </Identifier>
                              </ScalarOperator>
                            </Else>
                          </IF>
                        </ScalarOperator>
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Column="Expr1006" />
                        <ScalarOperator ScalarString="CASE WHEN [globalagg1019]=(0) THEN NULL ELSE [globalagg1021] END">
                          <IF>
                            <Condition>
                              <ScalarOperator>
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="globalagg1019" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="(0)" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Condition>
                            <Then>
                              <ScalarOperator>
                                <Const ConstValue="NULL" />
                              </ScalarOperator>
                            </Then>
                            <Else>
                              <ScalarOperator>
                                <Identifier>
                                  <ColumnReference Column="globalagg1021" />
                                </Identifier>
                              </ScalarOperator>
                            </Else>
                          </IF>
                        </ScalarOperator>
                      </DefinedValue>
                    </DefinedValues>
                    <RelOp NodeId="3" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.9e-006" AvgRowSize="39" EstimatedTotalSubtreeCost="666.327" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                      <OutputList>
                        <ColumnReference Column="globalagg1013" />
                        <ColumnReference Column="globalagg1015" />
                        <ColumnReference Column="globalagg1017" />
                        <ColumnReference Column="globalagg1019" />
                        <ColumnReference Column="globalagg1021" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                      </RunTimeInformation>
                      <StreamAggregate>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="globalagg1013" />
                            <ScalarOperator ScalarString="SUM([partialagg1012])">
                              <Aggregate Distinct="0" AggType="SUM">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="partialagg1012" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Column="globalagg1015" />
                            <ScalarOperator ScalarString="SUM([partialagg1014])">
                              <Aggregate Distinct="0" AggType="SUM">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="partialagg1014" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Column="globalagg1017" />
                            <ScalarOperator ScalarString="SUM([partialagg1016])">
                              <Aggregate Distinct="0" AggType="SUM">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="partialagg1016" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Column="globalagg1019" />
                            <ScalarOperator ScalarString="SUM([partialagg1018])">
                              <Aggregate Distinct="0" AggType="SUM">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="partialagg1018" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Column="globalagg1021" />
                            <ScalarOperator ScalarString="SUM([partialagg1020])">
                              <Aggregate Distinct="0" AggType="SUM">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="partialagg1020" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <RelOp NodeId="4" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="4" EstimateIO="0" EstimateCPU="0.0285057" AvgRowSize="39" EstimatedTotalSubtreeCost="666.327" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                          <OutputList>
                            <ColumnReference Column="partialagg1012" />
                            <ColumnReference Column="partialagg1014" />
                            <ColumnReference Column="partialagg1016" />
                            <ColumnReference Column="partialagg1018" />
                            <ColumnReference Column="partialagg1020" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
                          </RunTimeInformation>
                          <Parallelism>
                            <RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4" EstimateIO="0" EstimateCPU="0.00080004" AvgRowSize="39" EstimatedTotalSubtreeCost="666.299" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                              <OutputList>
                                <ColumnReference Column="partialagg1012" />
                                <ColumnReference Column="partialagg1014" />
                                <ColumnReference Column="partialagg1016" />
                                <ColumnReference Column="partialagg1018" />
                                <ColumnReference Column="partialagg1020" />
                              </OutputList>
                              <ComputeScalar>
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Column="partialagg1014" />
                                    <ScalarOperator ScalarString="[partialagg1012]">
                                      <Identifier>
                                        <ColumnReference Column="partialagg1012" />
                                      </Identifier>
                                    </ScalarOperator>
                                  </DefinedValue>
                                  <DefinedValue>
                                    <ColumnReference Column="partialagg1018" />
                                    <ScalarOperator ScalarString="[partialagg1012]">
                                      <Identifier>
                                        <ColumnReference Column="partialagg1012" />
                                      </Identifier>
                                    </ScalarOperator>
                                  </DefinedValue>
                                </DefinedValues>
                                <RelOp NodeId="6" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="4" EstimateIO="0" EstimateCPU="0.00080004" AvgRowSize="39" EstimatedTotalSubtreeCost="666.299" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                  <OutputList>
                                    <ColumnReference Column="partialagg1012" />
                                    <ColumnReference Column="partialagg1016" />
                                    <ColumnReference Column="partialagg1020" />
                                  </OutputList>
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="8" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="2" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="6" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="3" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="4" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="5" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="7" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                  </RunTimeInformation>
                                  <StreamAggregate>
                                    <DefinedValues>
                                      <DefinedValue>
                                        <ColumnReference Column="partialagg1012" />
                                        <ScalarOperator ScalarString="Count(*)">
                                          <Aggregate AggType="countstar" Distinct="0" />
                                        </ScalarOperator>
                                      </DefinedValue>
                                      <DefinedValue>
                                        <ColumnReference Column="partialagg1016" />
                                        <ScalarOperator ScalarString="SUM([Expr1008])">
                                          <Aggregate Distinct="0" AggType="SUM">
                                            <ScalarOperator>
                                              <Identifier>
                                                <ColumnReference Column="Expr1008" />
                                              </Identifier>
                                            </ScalarOperator>
                                          </Aggregate>
                                        </ScalarOperator>
                                      </DefinedValue>
                                      <DefinedValue>
                                        <ColumnReference Column="partialagg1020" />
                                        <ScalarOperator ScalarString="SUM([Expr1009])">
                                          <Aggregate Distinct="0" AggType="SUM">
                                            <ScalarOperator>
                                              <Identifier>
                                                <ColumnReference Column="Expr1009" />
                                              </Identifier>
                                            </ScalarOperator>
                                          </Aggregate>
                                        </ScalarOperator>
                                      </DefinedValue>
                                    </DefinedValues>
                                    <RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5330.27" EstimateIO="0" EstimateCPU="22.5742" AvgRowSize="15" EstimatedTotalSubtreeCost="666.298" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                      <OutputList>
                                        <ColumnReference Column="Expr1008" />
                                        <ColumnReference Column="Expr1009" />
                                      </OutputList>
                                      <MemoryFractions Input="1" Output="1" />
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="8" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="2" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="6" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="3" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="4" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="5" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="7" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="1" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                      </RunTimeInformation>
                                      <Hash>
                                        <DefinedValues />
                                        <HashKeysBuild>
                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                        </HashKeysBuild>
                                        <HashKeysProbe>
                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                        </HashKeysProbe>
                                        <ProbeResidual>
                                          <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[AcceptedAnswerId] as [q].[AcceptedAnswerId]=[StackOverflow.Exported].[dbo].[Posts].[Id] as [a].[Id]">
                                            <Compare CompareOp="EQ">
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                </Identifier>
                                              </ScalarOperator>
                                            </Compare>
                                          </ScalarOperator>
                                        </ProbeResidual>
                                        <RelOp NodeId="8" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="89.6622" EstimateIO="0" EstimateCPU="0.0288041" AvgRowSize="19" EstimatedTotalSubtreeCost="0.49909" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                          <OutputList>
                                            <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                            <ColumnReference Column="Expr1008" />
                                            <ColumnReference Column="Expr1009" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="4" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="8" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="3" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="6" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="7" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="2" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="5" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="1" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                          </RunTimeInformation>
                                          <Bitmap>
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Column="Bitmap1025" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <HashKeys>
                                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                            </HashKeys>
                                            <RelOp NodeId="9" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="89.6622" EstimateIO="0" EstimateCPU="0.0288041" AvgRowSize="19" EstimatedTotalSubtreeCost="0.49909" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                              <OutputList>
                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                <ColumnReference Column="Expr1008" />
                                                <ColumnReference Column="Expr1009" />
                                              </OutputList>
                                              <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="8" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="4" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="7" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="3" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="6" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="5" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="2" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="1" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                              </RunTimeInformation>
                                              <Parallelism PartitioningType="Broadcast">
                                                <RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="89.6622" EstimateIO="0" EstimateCPU="8.96622e-006" AvgRowSize="19" EstimatedTotalSubtreeCost="0.470286" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                                  <OutputList>
                                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                    <ColumnReference Column="Expr1008" />
                                                    <ColumnReference Column="Expr1009" />
                                                  </OutputList>
                                                  <ComputeScalar>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Column="Expr1008" />
                                                        <ScalarOperator ScalarString="CASE WHEN [StackOverflow.Exported].[dbo].[Posts].[Score] as [a].[Score]=(0) THEN (0) ELSE (1) END">
                                                          <IF>
                                                            <Condition>
                                                              <ScalarOperator>
                                                                <Compare CompareOp="EQ">
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Score" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="(0)" />
                                                                  </ScalarOperator>
                                                                </Compare>
                                                              </ScalarOperator>
                                                            </Condition>
                                                            <Then>
                                                              <ScalarOperator>
                                                                <Const ConstValue="(0)" />
                                                              </ScalarOperator>
                                                            </Then>
                                                            <Else>
                                                              <ScalarOperator>
                                                                <Const ConstValue="(1)" />
                                                              </ScalarOperator>
                                                            </Else>
                                                          </IF>
                                                        </ScalarOperator>
                                                      </DefinedValue>
                                                      <DefinedValue>
                                                        <ColumnReference Column="Expr1009" />
                                                        <ScalarOperator ScalarString="CASE WHEN [StackOverflow.Exported].[dbo].[Posts].[Score] as [a].[Score]=(0) THEN (1) ELSE (0) END">
                                                          <IF>
                                                            <Condition>
                                                              <ScalarOperator>
                                                                <Compare CompareOp="EQ">
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Score" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="(0)" />
                                                                  </ScalarOperator>
                                                                </Compare>
                                                              </ScalarOperator>
                                                            </Condition>
                                                            <Then>
                                                              <ScalarOperator>
                                                                <Const ConstValue="(1)" />
                                                              </ScalarOperator>
                                                            </Then>
                                                            <Else>
                                                              <ScalarOperator>
                                                                <Const ConstValue="(0)" />
                                                              </ScalarOperator>
                                                            </Else>
                                                          </IF>
                                                        </ScalarOperator>
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <RelOp NodeId="11" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="125.638" EstimateIO="0" EstimateCPU="0.0286" AvgRowSize="16" EstimatedTotalSubtreeCost="0.470217" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                      <OutputList>
                                                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Score" />
                                                      </OutputList>
                                                      <RunTimeInformation>
                                                        <RunTimeCountersPerThread Thread="1" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                                                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                      </RunTimeInformation>
                                                      <Parallelism>
                                                        <RelOp NodeId="12" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="125.638" EstimateIO="0" EstimateCPU="0.000131292" AvgRowSize="16" EstimatedTotalSubtreeCost="0.441617" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                          <OutputList>
                                                            <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                            <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Score" />
                                                          </OutputList>
                                                          <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="7" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="4" ActualRows="18" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="8" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="6" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="2" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="5" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="3" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="1" ActualRows="18" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                          </RunTimeInformation>
                                                          <NestedLoops Optimized="0" WithUnorderedPrefetch="1">
                                                            <OuterReferences>
                                                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                              <ColumnReference Column="Expr1024" />
                                                            </OuterReferences>
                                                            <RelOp NodeId="14" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="125.638" EstimateIO="0" EstimateCPU="0.0287354" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0321556" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                              <OutputList>
                                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                              </OutputList>
                                                              <RunTimeInformation>
                                                                <RunTimeCountersPerThread Thread="7" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                                <RunTimeCountersPerThread Thread="6" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                                <RunTimeCountersPerThread Thread="2" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                                <RunTimeCountersPerThread Thread="8" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                                <RunTimeCountersPerThread Thread="4" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                                <RunTimeCountersPerThread Thread="5" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                                <RunTimeCountersPerThread Thread="3" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                                <RunTimeCountersPerThread Thread="1" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                              </RunTimeInformation>
                                                              <Parallelism PartitioningType="RoundRobin">
                                                                <RelOp NodeId="15" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="125.638" EstimateIO="0.003125" EstimateCPU="0.000295202" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0034202" TableCardinality="4.18708e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                  </OutputList>
                                                                  <RunTimeInformation>
                                                                    <RunTimeCountersPerThread Thread="1" ActualRows="163" ActualEndOfScans="1" ActualExecutions="1" />
                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                                  </RunTimeInformation>
                                                                  <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                                    <DefinedValues>
                                                                      <DefinedValue>
                                                                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                      </DefinedValue>
                                                                    </DefinedValues>
                                                                    <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxPostOwner]" Alias="[a]" IndexKind="NonClustered" />
                                                                    <SeekPredicates>
                                                                      <SeekPredicateNew>
                                                                        <SeekKeys>
                                                                          <Prefix ScanType="EQ">
                                                                            <RangeColumns>
                                                                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="OwnerUserId" />
                                                                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="CommunityOwnedDate" />
                                                                            </RangeColumns>
                                                                            <RangeExpressions>
                                                                              <ScalarOperator ScalarString="(1)">
                                                                                <Const ConstValue="(1)" />
                                                                              </ScalarOperator>
                                                                              <ScalarOperator ScalarString="NULL">
                                                                                <Const ConstValue="NULL" />
                                                                              </ScalarOperator>
                                                                            </RangeExpressions>
                                                                          </Prefix>
                                                                        </SeekKeys>
                                                                      </SeekPredicateNew>
                                                                    </SeekPredicates>
                                                                  </IndexScan>
                                                                </RelOp>
                                                              </Parallelism>
                                                            </RelOp>
                                                            <RelOp NodeId="17" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="89.6622" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="12" EstimatedTotalSubtreeCost="0.40933" TableCardinality="4.18708e+006" Parallel="1" EstimateRebinds="124.638" EstimateRewinds="0">
                                                              <OutputList>
                                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Score" />
                                                              </OutputList>
                                                              <RunTimeInformation>
                                                                <RunTimeCountersPerThread Thread="4" ActualRows="18" ActualEndOfScans="2" ActualExecutions="20" />
                                                                <RunTimeCountersPerThread Thread="7" ActualRows="19" ActualEndOfScans="1" ActualExecutions="20" />
                                                                <RunTimeCountersPerThread Thread="8" ActualRows="19" ActualEndOfScans="1" ActualExecutions="20" />
                                                                <RunTimeCountersPerThread Thread="6" ActualRows="19" ActualEndOfScans="1" ActualExecutions="20" />
                                                                <RunTimeCountersPerThread Thread="2" ActualRows="20" ActualEndOfScans="1" ActualExecutions="21" />
                                                                <RunTimeCountersPerThread Thread="5" ActualRows="19" ActualEndOfScans="1" ActualExecutions="20" />
                                                                <RunTimeCountersPerThread Thread="3" ActualRows="19" ActualEndOfScans="2" ActualExecutions="21" />
                                                                <RunTimeCountersPerThread Thread="1" ActualRows="18" ActualEndOfScans="3" ActualExecutions="21" />
                                                                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                              </RunTimeInformation>
                                                              <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Score" />
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxId]" Alias="[a]" TableReferenceId="-1" IndexKind="Clustered" />
                                                                <SeekPredicates>
                                                                  <SeekPredicateNew>
                                                                    <SeekKeys>
                                                                      <Prefix ScanType="EQ">
                                                                        <RangeColumns>
                                                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                        </RangeColumns>
                                                                        <RangeExpressions>
                                                                          <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[Id] as [a].[Id]">
                                                                            <Identifier>
                                                                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                            </Identifier>
                                                                          </ScalarOperator>
                                                                        </RangeExpressions>
                                                                      </Prefix>
                                                                    </SeekKeys>
                                                                  </SeekPredicateNew>
                                                                </SeekPredicates>
                                                                <Predicate>
                                                                  <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[PostTypeId] as [a].[PostTypeId]=(2)">
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="PostTypeId" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="(2)" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                </Predicate>
                                                              </IndexScan>
                                                            </RelOp>
                                                          </NestedLoops>
                                                        </RelOp>
                                                      </Parallelism>
                                                    </RelOp>
                                                  </ComputeScalar>
                                                </RelOp>
                                              </Parallelism>
                                            </RelOp>
                                          </Bitmap>
                                        </RelOp>
                                        <RelOp NodeId="26" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="4.10726e+006" EstimateIO="641.571" EstimateCPU="1.15149" AvgRowSize="15" EstimatedTotalSubtreeCost="642.722" TableCardinality="4.18708e+006" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                          <OutputList>
                                            <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="4" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="8" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="3" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="6" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="5" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="2" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="7" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="1" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                          </RunTimeInformation>
                                          <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxId]" Alias="[q]" IndexKind="Clustered" />
                                            <Predicate>
                                              <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[OwnerUserId] as [q].[OwnerUserId]&lt;&gt;(1) AND PROBE([Bitmap1025],[StackOverflow.Exported].[dbo].[Posts].[AcceptedAnswerId] as [q].[AcceptedAnswerId],N'[IN ROW]')">
                                                <Logical Operation="AND">
                                                  <ScalarOperator>
                                                    <Compare CompareOp="NE">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="OwnerUserId" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="(1)" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Intrinsic FunctionName="PROBE">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Bitmap1025" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="N'[IN ROW]'" />
                                                      </ScalarOperator>
                                                    </Intrinsic>
                                                  </ScalarOperator>
                                                </Logical>
                                              </ScalarOperator>
                                            </Predicate>
                                          </IndexScan>
                                        </RelOp>
                                      </Hash>
                                    </RelOp>
                                  </StreamAggregate>
                                </RelOp>
                              </ComputeScalar>
                            </RelOp>
                          </Parallelism>
                        </RelOp>
                      </StreamAggregate>
                    </RelOp>
                  </ComputeScalar>
                </RelOp>
              </ComputeScalar>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>